SELECT m.BrandName, SUM(sd.Quantity) AS TotalSold
FROM (Sale_Detail sd INNER JOIN Sale_Transaction st ON sd.SaleID = st.SaleID)
INNER JOIN Medicine m ON sd.MedicineID = m.MedicineID
WHERE st.SaleDate BETWEEN Date() - 7 AND Date()
GROUP BY m.BrandName;